[dbo].[AtomPanelPurposeRef]

Property	Value
Created	10:31:13 AM Tuesday, March 02, 2010
Last Modified	11:40:00 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)
AtomPanelPurposeCode	smallint	2
AtomPanelPurposeDesc	nvarchar(50)	100
AtomPanelPurposeName	nvarchar(50)	100

	Name	Columns	Unique
	PK_AtomPanelPurposeRef	AtomPanelPurposeCode
	AK_AtomPanelPurposeRef_AtomPanelPurposeDesc	AtomPanelPurposeDesc
	AK_AtomPanelPurposeRef_AtomPanelPurposeName	AtomPanelPurposeName

SQL Script

CREATE TABLE [dbo].[AtomPanelPurposeRef]
(
[AtomPanelPurposeCode] [smallint] NOT NULL,
[AtomPanelPurposeDesc] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AtomPanelPurposeName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AtomPanelPurposeRef] ADD CONSTRAINT [PK_AtomPanelPurposeRef] PRIMARY KEY CLUSTERED ([AtomPanelPurposeCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AtomPanelPurposeRef] ADD CONSTRAINT [AK_AtomPanelPurposeRef_AtomPanelPurposeDesc] UNIQUE NONCLUSTERED ([AtomPanelPurposeDesc]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AtomPanelPurposeRef] ADD CONSTRAINT [AK_AtomPanelPurposeRef_AtomPanelPurposeName] UNIQUE NONCLUSTERED ([AtomPanelPurposeName]) ON [PRIMARY]
GO